package com.hotai.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.hotai.comment.pojo.Courseware;
import com.hotai.comment.pojo.CoursewareBaoStudent;
import com.hotai.comment.pojo.CoursewareTop;
import com.hotai.vo.bao.Baogao;
import com.hotai.vo.bao.CoursewareBaoStudentList;
import com.hotai.vo.courseware.*;
import com.hotai.vo.sho.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@Mapper
public interface CoursewareMapper extends BaseMapper<Courseware> {

    ArrayList<Coursewaredetaile> detaile(@Param("queryware") CoursewaredetaileList queryware);

    ArrayList<CoursewaredetaileShe> detaileshe(@Param("queryware")  CoursewaredetaileList queryware);

    void xiajia(@Param("jia")  Coursewarejia coursewarejia);

    void shangjia(@Param("jia") Coursewarejia coursewarejia);

    void delt(@Param("id")  Integer id);

    ArrayList<XueShoLIst> StuSho(@Param("queryware") XueSho xueSho);

    ArrayList<Xueshi> StuShi(@Param("queryware") CoursewaredetaileList queryware);

    ArrayList<GuanShoList> GuanShoList(@Param("queryware")  GuanSho guanSho);

    Integer zengYuan();

    Integer Leishi();

    void deleteSheId(@Param("cid") Integer cid,@Param("eid") Integer eid);

    void StushiDelete(@Param("id")Integer id);

    Baogao baogao(@Param("id") Integer id);

    Baogao pin(@Param("sid")Integer sid,@Param("cid") Integer cid);

    ArrayList<CoursewareBaoStudentList> bu(@Param("id") Integer id);

    ArrayList<CoursewareLIstZhan> CoursewareList(@Param("query") CoursewareList query);

    ArrayList<CoursewareLIstZhan> CoursewareShi();

    ArrayList<ShoTop> shoTOP(@Param("fname") String fname);

    ArrayList<CoursewareBaoStudentList> buPin(@Param("cid")  Integer cid,@Param("sid") Integer sid);

    Integer fenshu(@Param("cid") Integer cid);

    Integer pinshi( @Param("cid") Integer cid,@Param("sid") Integer sid);

    Integer soushi(@Param("cid") Integer cid);

    Integer shijian(@Param("xue") Date xueDate,@Param("cid") Integer cid,@Param("sid") Integer sid);

    Integer accomplish(@Param("id") Integer id);

    Integer beyond(@Param("score")Integer score,@Param("cid") Integer cid);

    Integer zongshu(@Param("cid") Integer cid);

    CoursewareTop CourseTop(@Param("id") Integer id);
}
